Readme: Data and programs for "The Role of Property Assessment Oversight in School Finance Inequality" by Alex Combs, John Foster, and Erin Troland

MASTER DO FILE
1. master_assessment_oversight.do
- executes all do files and outputs a log file containing results from the main analysis
- final analysis was run using Stata 18.0 BE-Basic Edition

COMPONENT DO FILES
	A. DATA IMPORTS AND CLEANING
		1. assessment_sales_ratio.do
		- prepares county-level assessment ratios used as dependent variables in the main analysis
			INPUT DATA
				a. Ratio Data 1978-1988.xlsx
				b. Ratio Data for 1989, 1990, 1993, 1996.xlsx
				c. Ratio Data for 1992, 1994, 1995, 1998.xlsx
				- Source: Kentucky Department of Revenue
			OUTPUT DATA
				i. assessment_sales_ratio_data.dta
		2. cntycoaldata.do
		- prepares county coal reserve data used for the indicator for top-quartile coal reserves
			INPUT DATA
				a. coal_est_remaining_resources1990-2014.dta
				- Source: Kentucky Department for Energy Development and Independence
				b. CWSR0000SA0.csv
				c. PCU21212121.csv
				- data for deflating coal prices
				- Source: Federal Reserve of St. Louis
			OUTPUT DATA
				i. cntycoal.dta
		3. dor_assessment_data_full.do
		- prepares county-level property assessments used as a dependent variable in the main analysis
			INPUT DATA
				a. dor_assessment_data_full.xlsx
				- Source: Kentucky Department of Revenue
			OUTPUT DATA
				i. dor_assessment_data_full.dta
		4. enrollmentccd.do
		- prepares school district enrollment and aggregated county-level enrollment
			INPUT DATA
				a. ag13yr.txt
				- Source: NCES Common Core of Data
			OUTPUT DATA
				i. distenrollmentccd.dta
				ii. cntyenrollmentccd.dta
		5. flespeced1987.do
		- prepares school district and county-level share of enrollment that is special education and free-lunch eligible 
			INPUT DATA
				a. ag13yr.txt
				- Source: NCES Common Core of Data
			OUTPUT DATA
				i. distflespeced1987.dta
				ii. cntyflespeced1987.dta
		6. ler1990.do
		- prepares school district levied equivalent tax rate (LER) in 1990 used as a covariate and enrollment weighted county-level LER for multi-district counties
			INPUT DATA
				a. kydist_ler_1990.xlsx
				- Source: Kentucky Department of Education 
			OUTPUT DATA
				i. kydist_ler_1990.dta
				ii. cntyler1990.dta
		7. netmig.do
		- prepares county net migration data used for robustness check
			INPUT DATA
				a. county_migration_data.xlsx
				- Source: Hauer, Matthew, and James Byars, 2019. "IRS County-to-County Migration Data, 1990-2010." Demographic Research 40, 1153-1166.
			OUTPUT DATA
				i. cntynetmig.dta				
		8. pophv.do
		- prepares district and county aggregate home value per school-aged person and population data
			INPUT DATA
				a. census1980.dta
				b. HSG03.xls
				c. AGE01.xls
				d. kycountypop19871998.xlsx
				- Source: U.S. Census
			OUTPUT DATA
				i. cntycensushv.dta
				ii. hv1980.dta
				iii. distagghv1980.dta
				iv. kycountypop19871998.dta
		9. cntyflepct19871998.do
		- prepares county-level percent free-lunch eligibility
			INPUT DATA
				a. kydistccd19871998.dta
				- Source: NCES Common Core of Data
			OUTPUT DATA
				i. cntyflepct19871998.dta
		10. performance_audit_clean.do
		- prepares performance audit data to compare local vs. state pre-treatment assessment accuracy (Figure 1) and long-term accuracy
			INPUT DATA
				a. KY_Assessment_Quality_Data.xlsx
				b. 2010 Property Assessment Performance Audit Results.xlsx
				c. 2014 Property Assessment Performance Audit Results.xlsx
				d. 2016 Property Assessment Performance Audit Results.xlsx
				e. 2018 Property Assessment Performance Audit Results.xlsx
				- Source: Kentucky Department of Revenue
			OUTPUT DATA
				i. performance_audit_clean.dta
	B. FINAL DATA PREPARATION
		1. pva_data_prep
		- prepares two datasets (county-level panel and school district-level panel) used for the main analysis
			INPUT DATA
				a. output data files from the above component do files
				b. pcepi.dta
				- Personal Consumption Expenditure Price Index from the Federal Reserve of St. Louis
				c. ncesid_kydistno_crosswalk
				d. kyf33_19871999
				- F-33 data from NCES and U.S. Census
				e. dist_revs_1990_2016
				- school district revenue data from the Kentucky Department of Education https://education.ky.gov/districts/FinRept/Pages/Historical-Revenues-and-Expenditures.aspx
				f. kydist_ler
				- district levied equivalent rates from the Kentucky Department of Education
			OUTPUT DATA
				i. pva_county_property.dta
				ii. pva_district_rev.dta
	C. ANALYSIS
		1. pva_analysis_final
		- runs main analysis reported that generates results reported in Figures 2, 3, and 4 and Appendix A and B
		2. Simulation_and_Implicit_Tax_Rate_Code
		- runs counterfactual simulation that generates results reported in Tables 2 and 3 and Online Appendix D







